{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Datos","CUOTA COMUNIDAD1 "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Datos","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,11,11,11]]}
["LOCALES","Seguro edificio  ","Mantenimiento ascensor","limpieza","luz","Viaqua  Agua ","Honorarios Administración","Fondo reserva","propietario ",null,null,"GASTOS MES","JUNIO"]
["Local A ",0.14000000000000001,0,0,0,0.1,0.1,0.1,"Zacil Romero Bravo",null,null,null,"mensual","anual"]
["Local B ",0.14000000000000001,0,0,0,0.1,0.1,0.1,"Silvia Vázquez Rego",null,null,"Seguro edificio ",{"$f":"N3/12","v":145.75},1749]
["1º A ",0.08,0.12,0.1,0.12,0.1,0.1,0.1,"Mara Contreras Fernández ",null,null,"Mantenimiento ascensor",{"$f":"N4/12","v":137},1644]
["1º B ",0.08,0.14000000000000001,0.1,0.12,0.1,0.1,0.1,"Antón Grande Estévez ",null,null,"limpieza",108]
["1º C ",0.08,0.14000000000000001,0.1,0.12,0.1,0.1,0.1,"Araceli Aboy Franco ",null,null,"luz",51.56]
["2º A ",0.08,0.12,0.12,0.1,0.1,0.1,0.1,"Alberto Cabarcos Paredes ",null,null,"Viaqua Agua ",12.21]
["2º B ",0.08,0.14000000000000001,0.12,0.1,0.1,0.1,0.1,"Soledad Coira Teijeiro",null,null,"Honorarios Administración",85]
["2º C ",0.08,0.14000000000000001,0.12,0.1,0.1,0.1,0.1,"Juan Vázquez Baldomar ",null,null,"Fondo reserva",{"$f":"ROUND(N12*5%/12,2)","v":53.63}]
["Ático A ",0.12,0.1,0.12,0.12,0.1,0.1,0.1,"José Carballo Coira "]
["Ático B",0.12,0.1,0.1,0.1,0.1,0.1,0.1,"Josefa Vázquez Baldomar ",null,null,"Último presupuesto ordinario "]
["Totales",{"$f":"SUM(B2:B11)","v":0.99999999999999989},{"$f":"SUM(C2:C11)","v":1},0.88,0.87999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,null,null,null,null,null,12872]

{"sheet":"CUOTA COMUNIDAD1 ","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[{"$f":"UPPER(\"Calculo de la cuota comunitaria por propietarios\")","v":"CALCULO DE LA CUOTA COMUNITARIA POR PROPIETARIOS"}]
[]
["PROPIETARIO"]
["Juan Vázquez Baldomar "]
["LOCAL","GASTOS","Seguro edificio  ","Mantenimiento ascensor","limpieza","luz","Viaqua  Agua ","Honorarios Administración","Fondo reserva","CUOTA MES"]
[{"$f":"VLOOKUP($A$4,CHOOSE({2,1},Datos!$A$2:$A$11,Datos!$I$2:$I$11),2,0)","v":"2º C "},"PORCENTAJES",{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(C$5,Datos!$B$1:$H$1,0))","v":0.08},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(D$5,Datos!$B$1:$H$1,0))","v":0.14000000000000001},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(E$5,Datos!$B$1:$H$1,0))","v":0.12},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(F$5,Datos!$B$1:$H$1,0))","v":0.1},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(G$5,Datos!$B$1:$H$1,0))","v":0.1},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(H$5,Datos!$B$1:$H$1,0))","v":0.1},{"$f":"INDEX(Datos!$B$2:$H$11,MATCH($A$6,Datos!$A$2:$A$11,0),MATCH(I$5,Datos!$B$1:$H$1,0))","v":0.1},{"$f":"SUMPRODUCT(Datos!$M$3:$M$9,TRANSPOSE($C$6:$I$6))","v":64.040000000000006}]
[]
[]
[null,"PORCENTAJES",{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(C$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.08},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(D$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.14000000000000001},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(E$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.12},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(F$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.1},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(G$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.1},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(H$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.1},{"$f":"INDIRECT(ADDRESS(MATCH($A$6,Datos!$A$1:$A$11,0),MATCH(I$5,Datos!$A$1:$H$1,0),4,,\"Datos\"))","v":0.1}]